clear *

use "${root}/data/processed/final_sample.dta", clear

keep if baseline_sample == 1

********* Perform (robust bias-corrected) RD estimates and produce results table **********

foreach outcome in tot_exp_avg_pc tot_exp_avg_sgdp tot_rev_avg_pc tot_rev_avg_sgdp current_exp_avg_share investments_avg_share personnel_avg_share social_exp_avg_share social_exp_avg_pc health_avg_share education_avg_share welfare_avg_share nonsocial_exp_avg_share housing_avg_share transport_avg_share social_exp_avg_pc {

*** (1) baseline (whole sample, average over 4-years, CCT 2014 MSE-optimal bandwidth)

	qui rdrobust res_`outcome' margin_mayor_left , vce(cluster mun_code) all

	local coeff1_`outcome' : di %9.2f (e(tau_bc))
	local se1_`outcome' : di %9.2f (e(se_tau_rb))
	local pv1_`outcome' : di %9.2f (e(pv_rb))
	local n1_`outcome' = e(N)
	local effn1_`outcome' = e(N_h_l) + e(N_h_r)


*** (2) same as (1) with IK kernel
	*qui rd res_`outcome' margin_mayor_left, vce(cluster mun_code) 
	*local ik_bw=e(w)
	qui rdrobust res_`outcome' margin_mayor_left , vce(cluster mun_code) bwselect("cerrd") all
	

	local coeff2_`outcome' : di %9.2f (e(tau_bc))
	local se2_`outcome' : di %9.2f (e(se_tau_rb))
	local pv2_`outcome' : di %9.2f (e(pv_rb))
	local n2_`outcome' = e(N)
	local effn2_`outcome' = e(N_h_l) + e(N_h_r)


*** (3) lame-ducks subsample (4-years average)

	qui rdrobust res_`outcome' margin_mayor_left if lame_duck == 1 & baseline==1, vce(cluster mun_code) all

	local coeff3_`outcome' : di %9.2f (e(tau_bc))
	local se3_`outcome' : di %9.2f (e(se_tau_rb))
	local pv3_`outcome' : di %9.2f (e(pv_rb))
	local n3_`outcome' = e(N)
	local effn3_`outcome' = e(N_h_l) + e(N_h_r)


*** (4) same as (3) with IK kernel
	qui rd res_`outcome' margin_mayor_left if lame_duck == 1 & baseline==1, vce(cluster mun_code) 
	local ik_bw=e(w)
	qui rdrobust res_`outcome' margin_mayor_left if lame_duck == 1 & baseline==1, vce(cluster mun_code) bwselect("cerrd") all

	local coeff4_`outcome' : di %9.2f (e(tau_bc))
	local se4_`outcome' : di %9.2f (e(se_tau_rb))
	local pv4_`outcome' : di %9.2f (e(pv_rb))
	local n4_`outcome' = e(N)
	local effn4_`outcome' = e(N_h_l) + e(N_h_r)



*** (5) Tiebout-below-median subsample (4-years average)

	qui rdrobust res_`outcome' margin_mayor_left if tiebout_median_sample == 1 & baseline_sample == 1, vce(cluster mun_code) all

	local coeff5_`outcome' : di %9.2f (e(tau_bc))
	local se5_`outcome' : di %9.2f (e(se_tau_rb))
	local pv5_`outcome' : di %9.2f (e(pv_rb))
	local n5_`outcome' = e(N)
	local effn5_`outcome' = e(N_h_l) + e(N_h_r)



*** (6) same as (5) with IK kernel
	qui rd res_`outcome' margin_mayor_left if tiebout_median_sample == 1 & baseline_sample == 1, vce(cluster mun_code) 
	local ik_bw=e(w)
	qui rdrobust res_`outcome' margin_mayor_left if tiebout_median_sample == 1 & baseline_sample == 1, vce(cluster mun_code) bwselect("cerrd") all

	local coeff6_`outcome' : di %9.2f (e(tau_bc))
	local se6_`outcome' : di %9.2f (e(se_tau_rb))
	local pv6_`outcome' : di %9.2f (e(pv_rb))
	local n6_`outcome' = e(N)
	local effn6_`outcome' = e(N_h_l) + e(N_h_r)



*** (7) Tiebout-below-75th percentile subsample (4-years average)

	qui rdrobust res_`outcome' margin_mayor_left if coal_dist_median_sample == 1 & baseline_sample == 1, vce(cluster mun_code) all

	local coeff7_`outcome' : di %9.2f (e(tau_bc))
	local se7_`outcome' : di %9.2f (e(se_tau_rb))
	local pv7_`outcome' : di %9.2f (e(pv_rb))
	local n7_`outcome' = e(N)
	local effn7_`outcome' = e(N_h_l) + e(N_h_r)



*** (8) same as (5) with IK kernel
	qui rd res_`outcome' margin_mayor_left if coal_dist_median_sample == 1 & baseline_sample == 1, vce(cluster mun_code) 
	local ik_bw=e(w)
	qui rdrobust res_`outcome' margin_mayor_left if coal_dist_median_sample == 1 & baseline_sample == 1, vce(cluster mun_code) bwselect("cerrd") all

	local coeff8_`outcome' : di %9.2f (e(tau_bc))
	local se8_`outcome' : di %9.2f (e(se_tau_rb))
	local pv8_`outcome' : di %9.2f (e(pv_rb))
	local n8_`outcome' = e(N)
	local effn8_`outcome' = e(N_h_l) + e(N_h_r)


*** (9) Oil-windfalls subsample (4-years average)

	qui rdrobust res_`outcome' margin_mayor_left if oil_sample == 1 & baseline_sample == 1, vce(cluster mun_code) all

	local coeff9_`outcome' : di %9.2f (e(tau_bc))
	local se9_`outcome' : di %9.2f (e(se_tau_rb))
	local pv9_`outcome' : di %9.2f (e(pv_rb))
	local n9_`outcome' = e(N)
	local effn9_`outcome' = e(N_h_l) + e(N_h_r)



*** (10) same as (9) with IK kernel
	qui rd res_`outcome' margin_mayor_left if oil_sample == 1 & baseline_sample == 1, vce(cluster mun_code) 
	local ik_bw=e(w)
	qui rdrobust res_`outcome' margin_mayor_left if oil_sample == 1 & baseline_sample == 1, vce(cluster mun_code) bwselect("cerrd") all

	local coeff10_`outcome' : di %9.2f (e(tau_bc))
	local se10_`outcome' : di %9.2f (e(se_tau_rb))
	local pv10_`outcome' : di %9.2f (e(pv_rb))
	local n10_`outcome' = e(N)
	local effn10_`outcome' = e(N_h_l) + e(N_h_r)


}


* write table
texdoc init "${root}/results/tables/table_aggregate_kernel.tex", replace force

tex \caption{RD estimates of the effect of a left-wing mayor: robustness to alternative bandwith selection}
tex \resizebox{\linewidth}{!}{
tex \begin{tabular}{lcccccccccc}
tex \toprule
tex 													&        \multicolumn{2}{c}{Baseline} 				& \multicolumn{8}{c}{Subsamples} 								\\
tex \cmidrule(lr){2-3} \cmidrule(lr){4-11}
tex 			& 	&														& \multicolumn{2}{c}{Lame Duck} 															& \multicolumn{2}{c}{Tiebout}	 													& \multicolumn{2}{c}{Ideology distance}   															& \multicolumn{2}{c}{Oil windfall}\\
tex 						& 									&										& 										&	 									& \multicolumn{2}{c}{$<$ median}	 												& \multicolumn{2}{c}{$>$ median}															& 																	\\
tex \cmidrule(lr){2-3} \cmidrule(lr){4-5} \cmidrule(lr){6-7} \cmidrule(lr){8-9} \cmidrule(lr){10-11}
tex  Outcome 						&        MSE 							&      CER   									&       MSE  									&    CER   									&    MSE					  			&        CER   								&      MSE   									&       CER  									&    MSE   									&    CER 					  	\\
tex \midrule
tex \multicolumn{11}{c}{Size of government: overall revenues and expenses} \\
tex \midrule
tex Expenditure per capita 			& `coeff1_tot_exp_avg_pc'`stars1_tot_exp_avg_pc' 			& `coeff2_tot_exp_avg_pc'`stars2_tot_exp_avg_pc' 				& `coeff3_tot_exp_avg_pc'`stars3_tot_exp_avg_pc' 				& `coeff4_tot_exp_avg_pc'`stars4_tot_exp_avg_pc' 				& `coeff5_tot_exp_avg_pc'`stars5_tot_exp_avg_pc' 			& `coeff6_tot_exp_avg_pc'`stars6_tot_exp_avg_pc' 			& `coeff7_tot_exp_avg_pc'`stars7_tot_exp_avg_pc' 				& `coeff8_tot_exp_avg_pc'`stars8_tot_exp_avg_pc' 				& `coeff9_tot_exp_avg_pc'`stars9_tot_exp_avg_pc' 				& `coeff10_tot_exp_avg_pc'`stars10_tot_exp_avg_pc' 	\\
tex  						& (`se1_tot_exp_avg_pc') 						& (`se2_tot_exp_avg_pc') 							& (`se3_tot_exp_avg_pc') 							& (`se4_tot_exp_avg_pc') 							& (`se5_tot_exp_avg_pc') 						& (`se6_tot_exp_avg_pc') 						& (`se7_tot_exp_avg_pc') 							& (`se8_tot_exp_avg_pc') 							& (`se9_tot_exp_avg_pc') 							& (`se10_tot_exp_avg_pc') 				\\
tex Expenditure, \% of GDP 			& `coeff1_tot_exp_avg_sgdp'`stars1_tot_exp_avg_sgdp' 			& `coeff2_tot_exp_avg_sgdp'`stars2_tot_exp_avg_sgdp' 		 		& `coeff3_tot_exp_avg_sgdp'`stars3_tot_exp_avg_sgdp' 		 		& `coeff4_tot_exp_avg_sgdp'`stars4_tot_exp_avg_sgdp' 		 		& `coeff5_tot_exp_avg_sgdp'`stars5_tot_exp_avg_sgdp' 		 	& `coeff6_tot_exp_avg_sgdp'`stars6_tot_exp_avg_sgdp' 			& `coeff7_tot_exp_avg_sgdp'`stars7_tot_exp_avg_sgdp' 		 		& `coeff8_tot_exp_avg_sgdp'`stars8_tot_exp_avg_sgdp' 		 		& `coeff9_tot_exp_avg_sgdp'`stars9_tot_exp_avg_sgdp' 		 		& `coeff10_tot_exp_avg_sgdp'`stars10_tot_exp_avg_sgdp' 	\\
tex  						& (`se1_tot_exp_avg_sgdp') 						& (`se2_tot_exp_avg_sgdp') 							& (`se3_tot_exp_avg_sgdp') 							& (`se4_tot_exp_avg_sgdp') 							& (`se5_tot_exp_avg_sgdp') 						& (`se6_tot_exp_avg_sgdp') 						& (`se7_tot_exp_avg_sgdp') 							& (`se8_tot_exp_avg_sgdp') 							& (`se9_tot_exp_avg_sgdp') 							& (`se10_tot_exp_avg_sgdp') 				\\
tex Revenue per capita 				& `coeff1_tot_rev_avg_pc'`stars1_tot_rev_avg_pc' 			& `coeff2_tot_rev_avg_pc'`stars2_tot_rev_avg_pc' 				& `coeff3_tot_rev_avg_pc'`stars3_tot_rev_avg_pc' 				& `coeff4_tot_rev_avg_pc'`stars4_tot_rev_avg_pc' 				& `coeff5_tot_rev_avg_pc'`stars5_tot_rev_avg_pc' 			& `coeff6_tot_rev_avg_pc'`stars6_tot_rev_avg_pc' 			& `coeff7_tot_rev_avg_pc'`stars7_tot_rev_avg_pc' 				& `coeff8_tot_rev_avg_pc'`stars8_tot_rev_avg_pc' 				& `coeff9_tot_rev_avg_pc'`stars9_tot_rev_avg_pc' 				& `coeff10_tot_rev_avg_pc'`stars10_tot_rev_avg_pc' 	\\
tex  						& (`se1_tot_rev_avg_pc') 						& (`se2_tot_rev_avg_pc') 							& (`se3_tot_rev_avg_pc') 							& (`se4_tot_rev_avg_pc') 							& (`se5_tot_rev_avg_pc') 						& (`se6_tot_rev_avg_pc') 						& (`se7_tot_rev_avg_pc') 							& (`se8_tot_rev_avg_pc') 							& (`se9_tot_rev_avg_pc') 							& (`se10_tot_rev_avg_pc') 				\\
tex Revenue, \% of GDP 				& `coeff1_tot_rev_avg_sgdp'`stars1_tot_rev_avg_sgdp' 			& `coeff2_tot_rev_avg_sgdp'`stars2_tot_rev_avg_sgdp' 				& `coeff3_tot_rev_avg_sgdp'`stars3_tot_rev_avg_sgdp' 				& `coeff4_tot_rev_avg_sgdp'`stars4_tot_rev_avg_sgdp' 				& `coeff5_tot_rev_avg_sgdp'`stars5_tot_rev_avg_sgdp' 			& `coeff6_tot_rev_avg_sgdp'`stars6_tot_rev_avg_sgdp' 			& `coeff7_tot_rev_avg_sgdp'`stars7_tot_rev_avg_sgdp' 				& `coeff8_tot_rev_avg_sgdp'`stars8_tot_rev_avg_sgdp' 				& `coeff9_tot_rev_avg_sgdp'`stars9_tot_rev_avg_sgdp' 				& `coeff10_tot_rev_avg_sgdp'`stars10_tot_rev_avg_sgdp' 	\\
tex  						& (`se1_tot_rev_avg_sgdp') 						& (`se2_tot_rev_avg_sgdp') 							& (`se3_tot_rev_avg_sgdp') 							& (`se4_tot_rev_avg_sgdp') 							& (`se5_tot_rev_avg_sgdp') 					 	& (`se6_tot_rev_avg_sgdp') 						& (`se7_tot_rev_avg_sgdp') 							& (`se8_tot_rev_avg_sgdp') 							& (`se9_tot_rev_avg_sgdp') 							& (`se10_tot_rev_avg_sgdp') 				\\
tex \midrule
tex \multicolumn{11}{c}{Allocation of resources: budget categories (\% of total expenditure)} \\
tex \midrule
tex Current Expenditure 			& `coeff1_current_exp_avg_share'`stars1_current_exp_avg_share' 		& `coeff2_current_exp_avg_share'`stars2_current_exp_avg_share' 			& `coeff3_current_exp_avg_share'`stars3_current_exp_avg_share' 			& `coeff4_current_exp_avg_share'`stars4_current_exp_avg_share' 			& `coeff5_current_exp_avg_share'`stars5_current_exp_avg_share' 		& `coeff6_current_exp_avg_share'`stars6_current_exp_avg_share' 		& `coeff7_current_exp_avg_share'`stars7_current_exp_avg_share' 			& `coeff8_current_exp_avg_share'`stars8_current_exp_avg_share' 			& `coeff9_current_exp_avg_share'`stars9_current_exp_avg_share' 			& `coeff10_current_exp_avg_share'`stars10_current_exp_avg_share' 	\\
tex  						& (`se1_current_exp_avg_share') 					& (`se2_current_exp_avg_share') 						& (`se3_current_exp_avg_share') 						& (`se4_current_exp_avg_share') 						& (`se5_current_exp_avg_share') 					& (`se6_current_exp_avg_share') 					& (`se7_current_exp_avg_share') 						& (`se8_current_exp_avg_share') 						& (`se9_current_exp_avg_share') 						& (`se10_current_exp_avg_share') 					\\
tex \multicolumn{11}{l}{of which:} \\
tex \hspace{0.20cm} Personnel 					& `coeff1_personnel_avg_share'`stars1_personnel_avg_share' 		& `coeff2_personnel_avg_share'`stars2_personnel_avg_share' 			& `coeff3_personnel_avg_share'`stars3_personnel_avg_share' 			& `coeff4_personnel_avg_share'`stars4_personnel_avg_share' 			& `coeff5_personnel_avg_share'`stars5_personnel_avg_share' 		& `coeff6_personnel_avg_share'`stars6_personnel_avg_share' 		& `coeff7_personnel_avg_share'`stars7_personnel_avg_share' 			& `coeff8_personnel_avg_share'`stars8_personnel_avg_share' 			& `coeff9_personnel_avg_share'`stars9_personnel_avg_share' 			& `coeff10_personnel_avg_share'`stars10_personnel_avg_share' 		\\
tex  						& (`se1_personnel_avg_share') 						& (`se2_personnel_avg_share') 							& (`se3_personnel_avg_share') 							& (`se4_personnel_avg_share') 							& (`se5_personnel_avg_share') 						& (`se6_personnel_avg_share') 						& (`se7_personnel_avg_share') 							& (`se8_personnel_avg_share') 							& (`se9_personnel_avg_share') 							& (`se10_personnel_avg_share') 						\\
tex Public Investment 				& `coeff1_investments_avg_share'`stars1_investments_avg_share' 		& `coeff2_investments_avg_share'`stars2_investments_avg_share' 			& `coeff3_investments_avg_share'`stars3_investments_avg_share' 			& `coeff4_investments_avg_share'`stars4_investments_avg_share' 			& `coeff5_investments_avg_share'`stars5_investments_avg_share' 		& `coeff6_investments_avg_share'`stars6_investments_avg_share' 		& `coeff7_investments_avg_share'`stars7_investments_avg_share' 			& `coeff8_investments_avg_share'`stars8_investments_avg_share' 			& `coeff9_investments_avg_share'`stars9_investments_avg_share' 			& `coeff10_investments_avg_share'`stars10_investments_avg_share' 	\\
tex  						& (`se1_investments_avg_share') 					& (`se2_investments_avg_share') 						& (`se3_investments_avg_share') 						& (`se4_investments_avg_share') 						& (`se5_investments_avg_share') 					& (`se6_investments_avg_share') 					& (`se7_investments_avg_share') 						& (`se8_investments_avg_share') 						& (`se9_investments_avg_share') 						& (`se10_investments_avg_share') 					\\
tex \midrule
tex \multicolumn{11}{c}{Allocation of resources: functional categories (\% of total expenditure)} \\
tex \midrule
tex Social Expenditures 			& `coeff1_social_exp_avg_share'`stars1_social_exp_avg_share' 		& `coeff2_social_exp_avg_share'`stars2_social_exp_avg_share' 			& `coeff3_social_exp_avg_share'`stars3_social_exp_avg_share' 			& `coeff4_social_exp_avg_share'`stars4_social_exp_avg_share' 			& `coeff5_social_exp_avg_share'`stars5_social_exp_avg_share' 		& `coeff6_social_exp_avg_share'`stars6_social_exp_avg_share' 		& `coeff7_social_exp_avg_share'`stars7_social_exp_avg_share' 			& `coeff8_social_exp_avg_share'`stars8_social_exp_avg_share' 			& `coeff9_social_exp_avg_share'`stars9_social_exp_avg_share' 			& `coeff10_social_exp_avg_share'`stars10_social_exp_avg_share' 		\\
tex  						& (`se1_social_exp_avg_share') 						& (`se2_social_exp_avg_share') 						 	& (`se3_social_exp_avg_share') 						 	& (`se4_social_exp_avg_share') 						 	& (`se5_social_exp_avg_share') 						& (`se6_social_exp_avg_share') 						& (`se7_social_exp_avg_share') 						 	& (`se8_social_exp_avg_share') 						 	& (`se9_social_exp_avg_share') 						 	& (`se10_social_exp_avg_share') 					\\
tex \multicolumn{11}{l}{of which:} \\                                                                                                                                                                                                                                                                                                                                                                                                           
tex \hspace{0.20cm} Health \& sanitation 	& `coeff1_health_avg_share'`stars1_health_avg_share' 			& `coeff2_health_avg_share'`stars2_health_avg_share' 				& `coeff3_health_avg_share'`stars3_health_avg_share' 				& `coeff4_health_avg_share'`stars4_health_avg_share' 				& `coeff5_health_avg_share'`stars5_health_avg_share' 			& `coeff6_health_avg_share'`stars6_health_avg_share' 			& `coeff7_health_avg_share'`stars7_health_avg_share' 				& `coeff8_health_avg_share'`stars8_health_avg_share' 				& `coeff9_health_avg_share'`stars9_health_avg_share' 				& `coeff10_health_avg_share'`stars10_health_avg_share' 			\\
tex  						& (`se1_health_avg_share') 						& (`se2_health_avg_share') 							& (`se3_health_avg_share') 							& (`se4_health_avg_share') 							& (`se5_health_avg_share') 						& (`se6_health_avg_share') 						& (`se7_health_avg_share') 							& (`se8_health_avg_share') 							& (`se9_health_avg_share') 							& (`se10_health_avg_share') 						\\
tex \hspace{0.20cm} Education \& culture 	& `coeff1_education_avg_share'`stars1_education_avg_share' 		& `coeff2_education_avg_share'`stars2_education_avg_share' 			& `coeff3_education_avg_share'`stars3_education_avg_share' 			& `coeff4_education_avg_share'`stars4_education_avg_share' 			& `coeff5_education_avg_share'`stars5_education_avg_share' 		& `coeff6_education_avg_share'`stars6_education_avg_share' 		& `coeff7_education_avg_share'`stars7_education_avg_share' 			& `coeff8_education_avg_share'`stars8_education_avg_share' 			& `coeff9_education_avg_share'`stars9_education_avg_share' 			& `coeff10_education_avg_share'`stars10_education_avg_share' 		\\
tex  						& (`se1_education_avg_share') 						& (`se2_education_avg_share') 							& (`se3_education_avg_share') 							& (`se4_education_avg_share') 							& (`se5_education_avg_share') 						& (`se6_education_avg_share') 						& (`se7_education_avg_share') 							& (`se8_education_avg_share') 							& (`se9_education_avg_share') 							& (`se10_education_avg_share') 						\\
tex \hspace{0.20cm} Social welfare 		& `coeff1_welfare_avg_share'`stars1_welfare_avg_share' 			& `coeff2_welfare_avg_share'`stars2_welfare_avg_share' 				& `coeff3_welfare_avg_share'`stars3_welfare_avg_share' 				& `coeff4_welfare_avg_share'`stars4_welfare_avg_share' 				& `coeff5_welfare_avg_share'`stars5_welfare_avg_share' 			& `coeff6_welfare_avg_share'`stars6_welfare_avg_share' 			& `coeff7_welfare_avg_share'`stars7_welfare_avg_share' 				& `coeff8_welfare_avg_share'`stars8_welfare_avg_share' 				& `coeff9_welfare_avg_share'`stars9_welfare_avg_share' 				& `coeff10_welfare_avg_share'`stars10_welfare_avg_share' 		\\
tex  						& (`se1_welfare_avg_share') 						& (`se2_welfare_avg_share') 							& (`se3_welfare_avg_share') 							& (`se4_welfare_avg_share') 							& (`se5_welfare_avg_share') 						& (`se6_welfare_avg_share') 						& (`se7_welfare_avg_share') 							& (`se8_welfare_avg_share') 							& (`se9_welfare_avg_share') 							& (`se10_welfare_avg_share') 						\\
tex \midrule                                                                                                                                                                                                                                                                                                                                                                                                                                    
*tex Other expenditures 			& `coeff1_nonsocial_exp_avg_share'`stars1_nonsocial_exp_avg_share'  	& `coeff2_nonsocial_exp_avg_share'`stars2_nonsocial_exp_avg_share'		& `coeff3_nonsocial_exp_avg_share'`stars3_nonsocial_exp_avg_share'		& `coeff4_nonsocial_exp_avg_share'`stars4_nonsocial_exp_avg_share'		& `coeff5_nonsocial_exp_avg_share'`stars5_nonsocial_exp_avg_share'	& `coeff6_nonsocial_exp_avg_share'`stars6_nonsocial_exp_avg_share'  	& `coeff7_nonsocial_exp_avg_share'`stars7_nonsocial_exp_avg_share'		& `coeff8_nonsocial_exp_avg_share'`stars8_nonsocial_exp_avg_share'		& `coeff9_nonsocial_exp_avg_share'`stars9_nonsocial_exp_avg_share'		& `coeff10_nonsocial_exp_avg_share'`stars10_nonsocial_exp_avg_share'	\\
*tex  						& (`se1_nonsocial_exp_avg_share') 					& (`se2_nonsocial_exp_avg_share') 						& (`se3_nonsocial_exp_avg_share') 						& (`se4_nonsocial_exp_avg_share') 						& (`se5_nonsocial_exp_avg_share') 					& (`se6_nonsocial_exp_avg_share') 					& (`se7_nonsocial_exp_avg_share') 						& (`se8_nonsocial_exp_avg_share') 						& (`se9_nonsocial_exp_avg_share') 						& (`se10_nonsocial_exp_avg_share') 					\\
tex \multicolumn{11}{l}{Other Expenditures:} \\                                                                                                                                                                                                                                                                                                                                                                                                           
tex \hspace{0.20cm} Housing 			& `coeff1_housing_avg_share'`stars1_housing_avg_share' 			& `coeff2_housing_avg_share'`stars2_housing_avg_share' 				& `coeff3_housing_avg_share'`stars3_housing_avg_share' 				& `coeff4_housing_avg_share'`stars4_housing_avg_share' 				& `coeff5_housing_avg_share'`stars5_housing_avg_share' 			& `coeff6_housing_avg_share'`stars6_housing_avg_share' 			& `coeff7_housing_avg_share'`stars7_housing_avg_share' 				& `coeff8_housing_avg_share'`stars8_housing_avg_share' 				& `coeff9_housing_avg_share'`stars9_housing_avg_share' 				& `coeff10_housing_avg_share'`stars10_housing_avg_share' 		\\
tex  						& (`se1_housing_avg_share') 						& (`se2_housing_avg_share') 							& (`se3_housing_avg_share') 							& (`se4_housing_avg_share') 							& (`se5_housing_avg_share') 						& (`se6_housing_avg_share') 						& (`se7_housing_avg_share') 							& (`se8_housing_avg_share') 							& (`se9_housing_avg_share') 							& (`se10_housing_avg_share') 						\\
tex \hspace{0.20cm} Transportation 		& `coeff1_transport_avg_share'`stars1_transport_avg_share' 		& `coeff2_transport_avg_share'`stars2_transport_avg_share' 			& `coeff3_transport_avg_share'`stars3_transport_avg_share' 			& `coeff4_transport_avg_share'`stars4_transport_avg_share' 			& `coeff5_transport_avg_share'`stars5_transport_avg_share' 		& `coeff6_transport_avg_share'`stars6_transport_avg_share' 		& `coeff7_transport_avg_share'`stars7_transport_avg_share' 			& `coeff8_transport_avg_share'`stars8_transport_avg_share' 			& `coeff9_transport_avg_share'`stars9_transport_avg_share' 			& `coeff10_transport_avg_share'`stars10_transport_avg_share' 		\\
tex  						& (`se1_transport_avg_share') 						& (`se2_transport_avg_share') 							& (`se3_transport_avg_share') 							& (`se4_transport_avg_share') 							& (`se5_transport_avg_share') 						& (`se6_transport_avg_share') 						& (`se7_transport_avg_share') 							& (`se8_transport_avg_share') 							& (`se9_transport_avg_share') 							& (`se10_transport_avg_share') 						\\
tex \hspace{0.20cm} Other 			& `coeff1_social_exp_avg_pc'`stars1_social_exp_avg_pc' 			& `coeff2_social_exp_avg_pc'`stars2_social_exp_avg_pc' 				& `coeff3_social_exp_avg_pc'`stars3_social_exp_avg_pc' 				& `coeff4_social_exp_avg_pc'`stars4_social_exp_avg_pc' 				& `coeff5_social_exp_avg_pc'`stars5_social_exp_avg_pc' 			& `coeff6_social_exp_avg_pc'`stars6_social_exp_avg_pc' 			& `coeff7_social_exp_avg_pc'`stars7_social_exp_avg_pc' 				& `coeff8_social_exp_avg_pc'`stars8_social_exp_avg_pc' 				& `coeff9_social_exp_avg_pc'`stars9_social_exp_avg_pc' 				& `coeff10_social_exp_avg_pc'`stars10_social_exp_avg_pc' 			\\
tex  						& (`se1_social_exp_avg_pc') 						& (`se2_social_exp_avg_pc') 							& (`se3_social_exp_avg_pc') 							& (`se4_social_exp_avg_pc') 							& (`se5_social_exp_avg_pc') 						& (`se6_social_exp_avg_pc') 						& (`se7_social_exp_avg_pc') 							& (`se8_social_exp_avg_pc') 							& (`se9_social_exp_avg_pc') 							& (`se10_social_exp_avg_pc') 						\\
tex \midrule
tex Social Expenditures per capita		& `coeff1_social_exp_avg_pc'`stars1_social_exp_avg_pc' 			& `coeff2_social_exp_avg_pc'`stars2_social_exp_avg_pc' 				& `coeff3_social_exp_avg_pc'`stars3_social_exp_avg_pc' 				& `coeff4_social_exp_avg_pc'`stars4_social_exp_avg_pc' 				& `coeff5_social_exp_avg_pc'`stars5_social_exp_avg_pc' 			& `coeff6_social_exp_avg_pc'`stars6_social_exp_avg_pc' 			& `coeff7_social_exp_avg_pc'`stars7_social_exp_avg_pc' 				& `coeff8_social_exp_avg_pc'`stars8_social_exp_avg_pc' 				& `coeff9_social_exp_avg_pc'`stars9_social_exp_avg_pc' 				& `coeff10_social_exp_avg_pc'`stars10_social_exp_avg_pc' 			\\
tex  						& (`se1_social_exp_avg_pc') 						& (`se2_social_exp_avg_pc') 							& (`se3_social_exp_avg_pc') 							& (`se4_social_exp_avg_pc') 							& (`se5_social_exp_avg_pc') 						& (`se6_social_exp_avg_pc') 						& (`se7_social_exp_avg_pc') 							& (`se8_social_exp_avg_pc') 							& (`se9_social_exp_avg_pc') 							& (`se10_social_exp_avg_pc') 						\\
tex \bottomrule
tex Observations (all) 				&  `n1_tot_exp_avg_pc'    		& `n2_tot_exp_avg_pc'  			& `n3_tot_exp_avg_pc'  			& `n4_tot_exp_avg_pc'  				& `n5_tot_exp_avg_pc'  		&  `n6_tot_exp_avg_pc'    		& `n7_tot_exp_avg_pc'  			& `n8_tot_exp_avg_pc'  			& `n9_tot_exp_avg_pc'  				& `n10_tot_exp_avg_pc'  		\\
tex Observations (effective)			&  `effn1_tot_exp_avg_pc'		& `effn2_tot_exp_avg_pc'		& `effn3_tot_exp_avg_pc'   		& `effn4_tot_exp_avg_pc'			& `effn5_tot_exp_avg_pc'   	&  `effn6_tot_exp_avg_pc'		& `effn7_tot_exp_avg_pc'		& `effn8_tot_exp_avg_pc'   		& `effn9_tot_exp_avg_pc'			& `effn10_tot_exp_avg_pc'   	\\
tex \bottomrule
tex \end{tabular}}

texdoc close
